Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	10127
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	168.0 B

Variable types

Numeric	17
Categorical	4

Warnings

`credit_limit` is highly correlated with `avg_open_to_buy`	High correlation
`avg_open_to_buy` is highly correlated with `credit_limit`	High correlation
`client_num` has unique values	Unique
`dependent_count` has 904 (8.9%) zeros	Zeros
`education` has 1519 (15.0%) zeros	Zeros
`income_category` has 1112 (11.0%) zeros	Zeros
`contacts_count_12_mon` has 399 (3.9%) zeros	Zeros
`total_revolving_bal` has 2470 (24.4%) zeros	Zeros
`avg_utilization_ratio` has 2470 (24.4%) zeros	Zeros

Reproduction

Analysis started	2021-01-20 19:24:52.992363
Analysis finished	2021-01-20 19:29:45.270750
Duration	4 minutes and 52.28 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

client_num
Real number (ℝ_≥0)

UNIQUE

Distinct	10127
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	739177606.3
Minimum	708082083
Maximum	828343083
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	708082083
5-th percentile	709120390.5
Q1	713036770.5
median	717926358
Q3	773143533
95-th percentile	814212033
Maximum	828343083
Range	120261000
Interquartile range (IQR)	60106762.5

Descriptive statistics

Standard deviation	36903783.45
Coefficient of variation (CV)	0.04992546194
Kurtosis	-0.6156397044
Mean	739177606.3
Median Absolute Deviation (MAD)	6347700
Skewness	0.9956010103
Sum	7.485651619 × 10¹²
Variance	1.361889233 × 10¹⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
780097533	1	< 0.1%
720049083	1	< 0.1%
717376758	1	< 0.1%
720598308	1	< 0.1%
719930658	1	< 0.1%
716805408	1	< 0.1%
819997983	1	< 0.1%
778191933	1	< 0.1%
824165658	1	< 0.1%
771220758	1	< 0.1%
Other values (10117)	10117	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
708082083	1	< 0.1%
708083283	1	< 0.1%
708084558	1	< 0.1%
708085458	1	< 0.1%
708086958	1	< 0.1%

Value	Count	Frequency (%)
828343083	1	< 0.1%
828298908	1	< 0.1%
828294933	1	< 0.1%
828291858	1	< 0.1%
828288333	1	< 0.1%

exists
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 KiB

1	8500
0	1627

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10127
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

Most occurring characters

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10127	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10127	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10127	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	8500	83.9%
0	1627	16.1%

age
Real number (ℝ_≥0)

Distinct	45
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46.3259603
Minimum	26
Maximum	73
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	26
5-th percentile	33
Q1	41
median	46
Q3	52
95-th percentile	60
Maximum	73
Range	47
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.016814033
Coefficient of variation (CV)	0.1730523011
Kurtosis	-0.2886199153
Mean	46.3259603
Median Absolute Deviation (MAD)	6
Skewness	-0.03360501632
Sum	469143
Variance	64.26930723
Monotocity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
44	500	4.9%
49	495	4.9%
46	490	4.8%
45	486	4.8%
47	479	4.7%
43	473	4.7%
48	472	4.7%
50	452	4.5%
42	426	4.2%
51	398	3.9%
Other values (35)	5456	53.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
26	78	0.8%
27	32	0.3%
28	29	0.3%
29	56	0.6%
30	70	0.7%

Value	Count	Frequency (%)
73	1	< 0.1%
70	1	< 0.1%
68	2	< 0.1%
67	4	< 0.1%
66	2	< 0.1%

female
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 KiB

1	5358
0	4769

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10127
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	1
5th row	0

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

Most occurring characters

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10127	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	10127	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10127	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	5358	52.9%
0	4769	47.1%

dependent_count
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.346203219
Minimum	0
Maximum	5
Zeros	904
Zeros (%)	8.9%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	4
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.298908349
Coefficient of variation (CV)	0.5536214162
Kurtosis	-0.6830166531
Mean	2.346203219
Median Absolute Deviation (MAD)	1
Skewness	-0.02082553562
Sum	23760
Variance	1.687162899
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	2732	27.0%
2	2655	26.2%
1	1838	18.1%
4	1574	15.5%
0	904	8.9%
5	424	4.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	904	8.9%
1	1838	18.1%
2	2655	26.2%
3	2732	27.0%
4	1574	15.5%

Value	Count	Frequency (%)
5	424	4.2%
4	1574	15.5%
3	2732	27.0%
2	2655	26.2%
1	1838	18.1%

education
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.601955169
Minimum	0
Maximum	6
Zeros	1519
Zeros (%)	15.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.700416503
Coefficient of variation (CV)	0.6535149118
Kurtosis	-1.005170191
Mean	2.601955169
Median Absolute Deviation (MAD)	1
Skewness	0.002252395754
Sum	26350
Variance	2.891416284
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	3128	30.9%
2	2013	19.9%
0	1519	15.0%
1	1487	14.7%
3	1013	10.0%
5	516	5.1%
6	451	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1519	15.0%
1	1487	14.7%
2	2013	19.9%
3	1013	10.0%
4	3128	30.9%

Value	Count	Frequency (%)
6	451	4.5%
5	516	5.1%
4	3128	30.9%
3	1013	10.0%
2	2013	19.9%

marital_status
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 KiB

2	4687
1	3943
0	749
3	748

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10127
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	2
4th row	0
5th row	2

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

Most occurring characters

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10127	100.0%

Most frequent character per category

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	10127	100.0%

Most frequent character per script

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10127	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	4687	46.3%
1	3943	38.9%
0	749	7.4%
3	748	7.4%

income_category
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.072578256
Minimum	0
Maximum	5
Zeros	1112
Zeros (%)	11.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.461928972
Coefficient of variation (CV)	0.7053673212
Kurtosis	-0.8568990602
Mean	2.072578256
Median Absolute Deviation (MAD)	1
Skewness	0.4807421784
Sum	20989
Variance	2.137236321
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	3561	35.2%
2	1790	17.7%
3	1535	15.2%
4	1402	13.8%
0	1112	11.0%
5	727	7.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1112	11.0%
1	3561	35.2%
2	1790	17.7%
3	1535	15.2%
4	1402	13.8%

Value	Count	Frequency (%)
5	727	7.2%
4	1402	13.8%
3	1535	15.2%
2	1790	17.7%
1	3561	35.2%

card
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 KiB

1	9436
2	555
3	116
4	20

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10127
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

Most occurring characters

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10127	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	10127	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10127	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	9436	93.2%
2	555	5.5%
3	116	1.1%
4	20	0.2%

months_on_book
Real number (ℝ_≥0)

Distinct	44
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35.9284092
Minimum	13
Maximum	56
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	13
5-th percentile	22
Q1	31
median	36
Q3	40
95-th percentile	50
Maximum	56
Range	43
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.986416331
Coefficient of variation (CV)	0.2222869453
Kurtosis	0.4001001202
Mean	35.9284092
Median Absolute Deviation (MAD)	4
Skewness	-0.1065653599
Sum	363847
Variance	63.78284581
Monotocity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
36	2463	24.3%
37	358	3.5%
34	353	3.5%
38	347	3.4%
39	341	3.4%
40	333	3.3%
31	318	3.1%
35	317	3.1%
33	305	3.0%
30	300	3.0%
Other values (34)	4692	46.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
13	70	0.7%
14	16	0.2%
15	34	0.3%
16	29	0.3%
17	39	0.4%

Value	Count	Frequency (%)
56	103	1.0%
55	42	0.4%
54	53	0.5%
53	78	0.8%
52	62	0.6%

total_relationship_count
Real number (ℝ_≥0)

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.812580231
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.554407865
Coefficient of variation (CV)	0.4077049586
Kurtosis	-1.006130507
Mean	3.812580231
Median Absolute Deviation (MAD)	1
Skewness	-0.162452415
Sum	38610
Variance	2.416183812
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	2305	22.8%
4	1912	18.9%
5	1891	18.7%
6	1866	18.4%
2	1243	12.3%
1	910	9.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	910	9.0%
2	1243	12.3%
3	2305	22.8%
4	1912	18.9%
5	1891	18.7%

Value	Count	Frequency (%)
6	1866	18.4%
5	1891	18.7%
4	1912	18.9%
3	2305	22.8%
2	1243	12.3%

months_inactive_12_mon
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.341167177
Minimum	0
Maximum	6
Zeros	29
Zeros (%)	0.3%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	4
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.010622399
Coefficient of variation (CV)	0.4316745978
Kurtosis	1.098522614
Mean	2.341167177
Median Absolute Deviation (MAD)	1
Skewness	0.633061129
Sum	23709
Variance	1.021357634
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	3846	38.0%
2	3282	32.4%
1	2233	22.0%
4	435	4.3%
5	178	1.8%
6	124	1.2%
0	29	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	29	0.3%
1	2233	22.0%
2	3282	32.4%
3	3846	38.0%
4	435	4.3%

Value	Count	Frequency (%)
6	124	1.2%
5	178	1.8%
4	435	4.3%
3	3846	38.0%
2	3282	32.4%

contacts_count_12_mon
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.455317468
Minimum	0
Maximum	6
Zeros	399
Zeros (%)	3.9%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	4
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.106225143
Coefficient of variation (CV)	0.4505426109
Kurtosis	0.0008626566254
Mean	2.455317468
Median Absolute Deviation (MAD)	1
Skewness	0.01100562622
Sum	24865
Variance	1.223734066
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	3380	33.4%
2	3227	31.9%
1	1499	14.8%
4	1392	13.7%
0	399	3.9%
5	176	1.7%
6	54	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	399	3.9%
1	1499	14.8%
2	3227	31.9%
3	3380	33.4%
4	1392	13.7%

Value	Count	Frequency (%)
6	54	0.5%
5	176	1.7%
4	1392	13.7%
3	3380	33.4%
2	3227	31.9%

credit_limit
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6205
Distinct (%)	61.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8631.953698
Minimum	1438.3
Maximum	34516
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	1438.3
5-th percentile	1438.51
Q1	2555
median	4549
Q3	11067.5
95-th percentile	34516
Maximum	34516
Range	33077.7
Interquartile range (IQR)	8512.5

Descriptive statistics

Standard deviation	9088.77665
Coefficient of variation (CV)	1.052922313
Kurtosis	1.808989336
Mean	8631.953698
Median Absolute Deviation (MAD)	2593
Skewness	1.666725808
Sum	87415795.1
Variance	82605861
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34516	508	5.0%
1438.3	507	5.0%
15987	18	0.2%
9959	18	0.2%
23981	12	0.1%
6224	11	0.1%
2490	11	0.1%
3735	11	0.1%
7469	10	0.1%
2069	8	0.1%
Other values (6195)	9013	89.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1438.3	507	5.0%
1439	2	< 0.1%
1440	1	< 0.1%
1441	2	< 0.1%
1442	1	< 0.1%

Value	Count	Frequency (%)
34516	508	5.0%
34496	1	< 0.1%
34458	1	< 0.1%
34427	1	< 0.1%
34198	1	< 0.1%

total_revolving_bal
Real number (ℝ_≥0)

ZEROS

Distinct	1974
Distinct (%)	19.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1162.814061
Minimum	0
Maximum	2517
Zeros	2470
Zeros (%)	24.4%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	359
median	1276
Q3	1784
95-th percentile	2517
Maximum	2517
Range	2517
Interquartile range (IQR)	1425

Descriptive statistics

Standard deviation	814.9873352
Coefficient of variation (CV)	0.7008750257
Kurtosis	-1.145991782
Mean	1162.814061
Median Absolute Deviation (MAD)	591
Skewness	-0.1488372503
Sum	11775818
Variance	664204.3566
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2470	24.4%
2517	508	5.0%
1965	12	0.1%
1480	12	0.1%
1720	11	0.1%
1664	11	0.1%
1434	11	0.1%
1542	10	0.1%
1175	10	0.1%
1560	10	0.1%
Other values (1964)	7062	69.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2470	24.4%
132	1	< 0.1%
134	1	< 0.1%
145	1	< 0.1%
154	1	< 0.1%

Value	Count	Frequency (%)
2517	508	5.0%
2514	3	< 0.1%
2513	1	< 0.1%
2512	2	< 0.1%
2511	1	< 0.1%

avg_open_to_buy
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6813
Distinct (%)	67.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	7469.139637
Minimum	3
Maximum	34516
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	3
5-th percentile	480.3
Q1	1324.5
median	3474
Q3	9859
95-th percentile	32183.4
Maximum	34516
Range	34513
Interquartile range (IQR)	8534.5

Descriptive statistics

Standard deviation	9090.685324
Coefficient of variation (CV)	1.217099394
Kurtosis	1.798617296
Mean	7469.139637
Median Absolute Deviation (MAD)	2665
Skewness	1.661696546
Sum	75639977.1
Variance	82640559.65
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1438.3	324	3.2%
34516	98	1.0%
31999	26	0.3%
787	8	0.1%
953	7	0.1%
701	7	0.1%
463	7	0.1%
713	7	0.1%
740	6	0.1%
933	6	0.1%
Other values (6803)	9631	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
10	1	< 0.1%
14	2	< 0.1%
15	1	< 0.1%
24	1	< 0.1%

Value	Count	Frequency (%)
34516	98	1.0%
34362	1	< 0.1%
34302	1	< 0.1%
34300	1	< 0.1%
34297	1	< 0.1%

total_amt_chng_q4_q1
Real number (ℝ_≥0)

Distinct	1158
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.7599406537
Minimum	0
Maximum	3.397
Zeros	5
Zeros (%)	< 0.1%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.463
Q1	0.631
median	0.736
Q3	0.859
95-th percentile	1.103
Maximum	3.397
Range	3.397
Interquartile range (IQR)	0.228

Descriptive statistics

Standard deviation	0.2192067692
Coefficient of variation (CV)	0.288452484
Kurtosis	9.993501179
Mean	0.7599406537
Median Absolute Deviation (MAD)	0.114
Skewness	1.732063411
Sum	7695.919
Variance	0.04805160768
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.791	36	0.4%
0.743	34	0.3%
0.712	34	0.3%
0.735	33	0.3%
0.718	33	0.3%
0.722	32	0.3%
0.744	32	0.3%
0.699	32	0.3%
0.767	31	0.3%
0.69	31	0.3%
Other values (1148)	9799	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	< 0.1%
0.01	1	< 0.1%
0.018	1	< 0.1%
0.046	1	< 0.1%
0.061	2	< 0.1%

Value	Count	Frequency (%)
3.397	1	< 0.1%
3.355	1	< 0.1%
2.675	1	< 0.1%
2.594	1	< 0.1%
2.368	1	< 0.1%

total_trans_amt
Real number (ℝ_≥0)

Distinct	5033
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4404.086304
Minimum	510
Maximum	18484
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	510
5-th percentile	1283.3
Q1	2155.5
median	3899
Q3	4741
95-th percentile	14212
Maximum	18484
Range	17974
Interquartile range (IQR)	2585.5

Descriptive statistics

Standard deviation	3397.129254
Coefficient of variation (CV)	0.7713584656
Kurtosis	3.894023406
Mean	4404.086304
Median Absolute Deviation (MAD)	1308
Skewness	2.041003403
Sum	44600182
Variance	11540487.17
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4253	11	0.1%
4509	11	0.1%
2229	10	0.1%
4518	10	0.1%
4869	9	0.1%
4042	9	0.1%
4313	9	0.1%
4220	9	0.1%
4498	9	0.1%
4037	9	0.1%
Other values (5023)	10031	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
510	1	< 0.1%
530	1	< 0.1%
563	1	< 0.1%
569	1	< 0.1%
594	1	< 0.1%

Value	Count	Frequency (%)
18484	1	< 0.1%
17995	1	< 0.1%
17744	1	< 0.1%
17634	1	< 0.1%
17628	1	< 0.1%

total_trans_ct
Real number (ℝ_≥0)

Distinct	126
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	64.85869458
Minimum	10
Maximum	139
Zeros	0
Zeros (%)	0.0%
Memory size	79.2 KiB

Quantile statistics

Minimum	10
5-th percentile	28
Q1	45
median	67
Q3	81
95-th percentile	105
Maximum	139
Range	129
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	23.47257045
Coefficient of variation (CV)	0.3619032206
Kurtosis	-0.3671632411
Mean	64.85869458
Median Absolute Deviation (MAD)	17
Skewness	0.1536730685
Sum	656824
Variance	550.9615635
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	208	2.1%
75	203	2.0%
71	203	2.0%
82	202	2.0%
69	202	2.0%
76	198	2.0%
77	197	1.9%
70	193	1.9%
78	190	1.9%
74	190	1.9%
Other values (116)	8141	80.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	4	< 0.1%
11	2	< 0.1%
12	4	< 0.1%
13	5	< 0.1%
14	9	0.1%

Value	Count	Frequency (%)
139	1	< 0.1%
138	1	< 0.1%
134	1	< 0.1%
132	1	< 0.1%
131	6	0.1%

total_ct_chng_q4_q1
Real number (ℝ_≥0)

Distinct	830
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.7122223758
Minimum	0
Maximum	3.714
Zeros	7
Zeros (%)	0.1%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.368
Q1	0.582
median	0.702
Q3	0.818
95-th percentile	1.069
Maximum	3.714
Range	3.714
Interquartile range (IQR)	0.236

Descriptive statistics

Standard deviation	0.2380860913
Coefficient of variation (CV)	0.3342861716
Kurtosis	15.6892929
Mean	0.7122223758
Median Absolute Deviation (MAD)	0.119
Skewness	2.064030568
Sum	7212.676
Variance	0.05668498689
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.667	171	1.7%
1	166	1.6%
0.5	161	1.6%
0.75	156	1.5%
0.6	113	1.1%
0.8	101	1.0%
0.714	92	0.9%
0.833	85	0.8%
0.778	69	0.7%
0.625	63	0.6%
Other values (820)	8950	88.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	0.1%
0.028	1	< 0.1%
0.029	1	< 0.1%
0.038	1	< 0.1%
0.053	1	< 0.1%

Value	Count	Frequency (%)
3.714	1	< 0.1%
3.571	1	< 0.1%
3.5	1	< 0.1%
3.25	1	< 0.1%
3	2	< 0.1%

avg_utilization_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	964
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2748935519
Minimum	0
Maximum	0.999
Zeros	2470
Zeros (%)	24.4%
Memory size	79.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.023
median	0.176
Q3	0.503
95-th percentile	0.793
Maximum	0.999
Range	0.999
Interquartile range (IQR)	0.48

Descriptive statistics

Standard deviation	0.2756914693
Coefficient of variation (CV)	1.002902641
Kurtosis	-0.7949719515
Mean	0.2748935519
Median Absolute Deviation (MAD)	0.176
Skewness	0.7180079968
Sum	2783.847
Variance	0.07600578622
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2470	24.4%
0.073	44	0.4%
0.057	33	0.3%
0.048	32	0.3%
0.06	30	0.3%
0.045	29	0.3%
0.061	29	0.3%
0.069	28	0.3%
0.059	28	0.3%
0.053	27	0.3%
Other values (954)	7377	72.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2470	24.4%
0.004	1	< 0.1%
0.005	1	< 0.1%
0.006	3	< 0.1%
0.007	1	< 0.1%

Value	Count	Frequency (%)
0.999	1	< 0.1%
0.995	1	< 0.1%
0.994	1	< 0.1%
0.992	1	< 0.1%
0.99	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	client_num	exists	age	female	dependent_count	education	marital_status	income_category	card	months_on_book	total_relationship_count	months_inactive_12_mon	contacts_count_12_mon	credit_limit	total_revolving_bal	avg_open_to_buy	total_amt_chng_q4_q1	total_trans_amt	total_trans_ct	total_ct_chng_q4_q1	avg_utilization_ratio
0	768805383	1	45	0	3	2	2	4	1	39	5	1	3	12691.0	777	11914.0	1.335	1144	42	1.625	0.061
1	818770008	1	49	1	5	4	1	1	1	44	6	1	2	8256.0	864	7392.0	1.541	1291	33	3.714	0.105
2	713982108	1	51	0	3	4	2	3	1	36	4	1	0	3418.0	0	3418.0	2.594	1887	20	2.333	0.000
3	769911858	1	40	1	4	2	0	1	1	34	3	4	1	3313.0	2517	796.0	1.405	1171	20	2.333	0.760
4	709106358	1	40	0	3	1	2	4	1	21	5	1	0	4716.0	0	4716.0	2.175	816	28	2.500	0.000
5	713061558	1	44	0	2	4	2	2	1	36	3	1	2	4010.0	1247	2763.0	1.376	1088	24	0.846	0.311
6	810347208	1	51	0	4	0	2	5	3	46	6	1	3	34516.0	2264	32252.0	1.975	1330	31	0.722	0.066
7	818906208	1	32	0	0	2	0	4	2	27	2	2	2	29081.0	1396	27685.0	2.204	1538	36	0.714	0.048
8	710930508	1	37	0	3	1	1	4	1	36	5	2	0	22352.0	2517	19835.0	3.355	1350	24	1.182	0.113
9	719661558	1	48	0	2	4	1	3	1	36	6	3	3	11656.0	1677	9979.0	1.524	1441	32	0.882	0.144

Last rows

	client_num	exists	age	female	dependent_count	education	marital_status	income_category	card	months_on_book	total_relationship_count	months_inactive_12_mon	contacts_count_12_mon	credit_limit	total_revolving_bal	avg_open_to_buy	total_amt_chng_q4_q1	total_trans_amt	total_trans_ct	total_ct_chng_q4_q1	avg_utilization_ratio
10117	712503408	1	57	0	2	4	2	3	1	40	6	3	4	17925.0	1909	16016.0	0.712	17498	111	0.820	0.106
10118	713755458	0	50	0	1	0	0	3	1	36	6	3	4	9959.0	952	9007.0	0.825	10310	63	1.100	0.096
10119	716893683	0	55	1	3	1	1	0	1	47	4	3	3	14657.0	2517	12140.0	0.166	6009	53	0.514	0.172
10120	710841183	1	54	0	1	2	1	4	1	34	5	2	0	13940.0	2109	11831.0	0.660	15577	114	0.754	0.151
10121	713899383	1	56	1	1	4	1	1	1	50	4	1	4	3688.0	606	3082.0	0.570	14596	120	0.791	0.164
10122	772366833	1	50	0	2	4	1	2	1	40	3	2	3	4003.0	1851	2152.0	0.703	15476	117	0.857	0.462
10123	710638233	0	41	0	2	0	3	2	1	25	4	2	3	4277.0	2186	2091.0	0.804	8764	69	0.683	0.511
10124	716506083	0	44	1	1	2	2	1	1	36	5	3	4	5409.0	0	5409.0	0.819	10291	60	0.818	0.000
10125	717406983	0	30	0	2	4	0	2	1	36	4	3	3	5281.0	0	5281.0	0.535	8395	62	0.722	0.000
10126	714337233	0	43	1	2	4	2	1	2	25	6	2	4	10388.0	1961	8427.0	0.703	10294	61	0.649	0.189

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows